Data Views

Different views of the data can be created for various user groups. Within these different data views it is possible to:

define fields as filters

display or not display fields

change the display order of the fields

displayed fields as read only or editable

apply more meaningful column headers

change the column heading to a more meaningful name

create a tooltip that will be displayed when the user hovers over the column heading

define default filter values

define default values to be used for new records

assign a lookup query to define valid lookup values

Data Views Fields

The table below list the attributes that determine whether a field from a table will be displayed and how for the data management queries tables.

Name	Description
Field Name	The data model field name given to the table field. For example: /Id is the unique identifier for the field /Location/Code is a field join to the Location table code field.
Description	The current description assigned to the data model name. This field can be altered.
Visible	Select this to display the field.
Order	Used to set the display sequence of the fields.
Read Only	Select this to display a field that cannot be edited.
Allow Free-Text	Select this to enable the entry of free text. If not selected for text fields, a valid entry will need to be selected/entered.
Show Filter	Select this to display the field as a filter.
Default Filter From Value	Enter a default value to use for the From Value filter.
Default Filter To Value	Enter a default value to use for the To Value filter.
Lookup Values	Select one of the lookup values to be applied to the field: <default>: Uses the default lookup set up for this field. <none>: No lookup will be used for this field. List of defined lookup queries. Uses the result from the selected defined lookup query to provide the valid lookup values. Refer to the Lookup Queries topic for information on how to create customised lookups. Note: Lookup values can only be set for character fields.
Extended Description	Extended descriptions are used in the tooltip when the user hovers over the column heading instead of the description. A more meaningful column header can be displayed.
Default New Value	Default value to be used for this field when creating a new record. This is useful when a field does not need to be displayed but must have a value entered ie the Created By field. They are also used to map fields from a table and related table(s) to the columns in a comma delimited (csv) file for importing into MiiNT.